-
Re: COUNTIFS formula troubleshooting - multiple criteria and checkboxes
Try the below: (You had an extra parenthesis at the end in both the formula and also changed =1 to just 1) =COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Oth…1 · -
Re: Nested IF isn't working
The reason you are getting zeroes is coz you are trying to match all of those conditions in a single range {TA_Offer Decline data Range 1} and if will always return false/0 as you cannot have all val…1 · -
Re: How do I concatenate text in a different sheet and a changing number
@User251 Apologies that I missed the important part in my formula, I meant to say please use this so that you can reference the cell from other sheet as a range, ="Calendar Year " + VALUE({…1 · -
Re: How do I concatenate text in a different sheet and a changing number
Use this, ="Calendar Year " + {That single cell selected as sheet1 range} - 2)1 · -
Re: Formula Help - SOS
Try this, hopefully that works: =COUNTIFS([Owner]:[Owner], AND(@cell <> "ABC Inc", @cell <> "GreyBird"), [Date]:[Date], DATE(2022, 2, 1) )1 ·